﻿<!--#include file="utf-8.asp"-->
<!--#include file="sql.asp"-->
<!--#include file="conn.asp"-->
<!--#include file="config.asp" -->
<%
'######################################
' 安科外贸网站管理系统中英文双语版
' anke Enterprise Web Site Management System
' 官方网站：http://www.shejifang.org
' 联系QQ：357052954
' 淘宝店： http://shejifang.taobao.com
'######################################
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Successful Cases-<%=config("etitle")%></title>
<meta name="keywords" content="<%=config("ekeywords")%>" />
<meta name="description" content="<%=config("edescription")%>" />
<link href="images/style.css" type="text/css" rel="stylesheet" />
</head>
<body>
<!--#include file="eheader.asp" -->
<table width="913" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td width="193" valign="top">
    <table width="193" border="0"  cellpadding="0" cellspacing="0">
      <tr>
        <td valign="top">
        <!--左侧导航-->
        <!--#include file="eleft4.asp"-->
        </td>
      </tr>
      <tr>
        <td width="193" height="324" align="center" valign="top">
        <!--热点产品-->
        <!--#include file="ehot.asp"-->
        </td>
      </tr>
    </table></td>
    <td width="720" valign="top">
    
    <table width="720" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td width="720" height="34" align="right" valign="middle" background="images/title.jpg">
        <span style="float:left; padding:2px 0px 0px 25px; font-weight:bold; font-size:14px; color:#333333;">SUCCESSFUL CASES</span>
        <a href="eindex.asp">Home</a> > <a href="ecases.asp?/1.html">Cases Center</a>
        </td>
	</tr>
	<tr>
		<td height="113">
			<img src="images/about_02.jpg" width="720" height="113"></td>
	</tr>
	<tr>
		<td valign="top">
        <!--案例显示-->
        <table width="720" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td width="720" height="35">
			<img src="images/cases_02_01.jpg" width="720" height="35"></td>
	</tr>
	<tr>
		<td width="720" valign="top"  background="images/right_02_02.jpg">
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          
          <tr>
            <td align="center" valign="top">
<%	
set rs=server.createobject("adodb.recordset") 
exec="select * from cases order by id desc" 
rs.open exec,conn,1,1 
if rs.eof then
response.Write "&nbsp;No Cases！"
else
rs.pagesize = 20 
allpage = rs.pagecount
allcount = rs.recordcount
'接收传过来的page页码
page=request.QueryString("page")    
If page="" Then     
server_v40=Request.ServerVariables("QUERY_STRING")    
page=Int(replace(replace(server_v40,"/",""),".html",""))  
End If 
	if page = "" then page = 1
	if isnumeric(page) then
		if clng(page) <1 then page = 1
		if clng(page) > rs.pagecount then page = rs.pagecount
	else	
		page = 1
	end if
	if not rs.eof then
		rs.absolutepage = page
	end if
%>
<%
For i=1 To rs.pagesize
if rs.eof then exit for
%>
<div style="float:left; margin:10px 0px 0px 10px;">
<table width="150" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td><div><a href="eshowcases.asp?/<%=rs("id")%>.html" title="<%=rs("etitle")%>" class="img"><img src="<%=rs("img")%>" width="150" height="150" /></a></div>    </td>
  </tr>
  <tr>
    <td height="30"><div align="center" style="font-weight:bold"><a href="eshowcases.asp?/<%=rs("id")%>.html" title="<%=rs("etitle")%>"><%=left(rs("etitle"),40)%></a></div></td>
  </tr>
</table>
</div>
<%rs.movenext
next
%>
<%
end if
%>

           </td>
          </tr>
        </table>
<p style="text-align:center;text-indent:40px;">
			Total of： <strong><%=allcount%></strong> records | 
			<%=page%>/<%=allpage%>Page | 
			<%if page = 1 then%>
			Home | 
			before | 
			<%else%>
			<a href="ecases.asp?/1.html">Home</a> | 
			<a href="ecases.asp?/<%=page-1%>.html">before</a> | 
			<%end if%>
			<%
				if clng(page) = allpage then
			%>
			Next | 
			Last 
			<%else%>
			<a href="ecases.asp?/<%=page+1%>.html">Next</a> | 
			<a href="ecases.asp?/<%=allpage%>.html">Last </a>
			<%end if%>
		</p>         
<%
rs.close
set rs=nothing
%> 
</td>
	</tr>
    <tr>
		<td width="720" height="15" valign="top"><img src="images/right_02_03.jpg" width="720" height="7" /></td>
	</tr>
</table>
        </td>
	</tr>
</table>
    
    </td>
  </tr>
</table>
<!--#include file="efoot.asp" -->
</body>
</html>
<%
conn.close
set conn = nothing
%>